Micron Document




Microsoft Azure SQL Database
part 4/8 · 12.1 KB total
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Popular use cases

• Relational data storage for cloud-based applications and websites
• Business and consumer web and mobile apps
• Manage databases for multi-tenant apps (software-as-a-service)
• Quickly create dev and test databases to speed up development cycles
• Scale production business services quickly and at a known cost
• Containerize data in the cloud for isolation and security
• Reduce database administration overhead through increased automation

Design

Azure SQL Database is built on the foundation of the SQL server database and therefore, kept in sync with the latest versioncite-ref-0-2-1[2] of it by using the common code base. Since the cloud version of the database technology strives to decouple it from the underlying computing infrastructure, it doesn't support some of the context specific T-SQL featurescite-ref-13[13] available in the traditional SQL server. However, the rest of the features are the same with incompatibilities spelled out by Microsoft.cite-ref-14[14] Azure SQL Database is also similar to Microsoft's SQL Managed instance offering, with some differences.cite-ref-15[15]

──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────